﻿<AdoNetDataAccess connection="$ContactsDBConnection$">
	<Sql>
    INSERT INTO CONTACTS
    (id,lastName,firstName,middleName,phone,mobile,email,isUser,typeId,companyId, dateCreated, dateUpdated,
      extId,avitarImage,customTitle,dateOfBirth,gender,location)
    VALUES(@id,@lastName,@firstName,@middleName,@phone,@mobile,@email,@isUser,@typeId,@companyId,@dateCreated, @dateUpdated,
      @extId,@avitarImage,@customTitle,@dateOfBirth,@gender,@location);
  </Sql>
	<Sql type="SqlServer">
	</Sql>
	<Param name="lastName" type="UnicodeVarChar" />
	<Param name="firstName" type="UnicodeVarChar" />
	<Param name="middleName" type="UnicodeVarChar" />
	<Param name="phone" type="UnicodeVarChar" />
	<Param name="mobile" type="UnicodeVarChar" />
	<Param name="email" type="UnicodeVarChar" />
	<Param name="type.id" dbName="typeId" type="UniqueIdentifier" />
	<Param name="id" type="UniqueIdentifier" />
	<Param name="companyId" type="UniqueIdentifier" />
	<Param name="isUser" type="Integer" />
  <Param name="dateCreated" type="Date" />
  <Param name="dateUpdated" type="Date" />
  <Param name="dateOfBirth" type="Date" />
  <Param name="extId" type="String" />
  <Param name="avitarImage" type="String" />
  <Param name="customTitle" type="String" />
  <Param name="gender" type="String" />
  <Param name="location" type="String" />
</AdoNetDataAccess>